package LOGISTICS.controller;

import javax.swing.JTable;

import TOOLS.SQLtool;
import LOGISTICS.LogisticsBean;
import LOGISTICS.mapper.WorkingRIDdtoMapper;

public class PickUpCtrller {
	
	public PickUpCtrller(SQLtool isql) {
		LogisticsBean.setSQLinfo(isql);
	}

	public JTable getWorkshopSurplusMaterials(String pickPlanOrder,String materialNumber) throws Exception {
		JTable t=WorkingRIDdtoMapper.getWorkshopSurplusMaterials(pickPlanOrder,materialNumber);
		return t;
	}
	
	public void setPickPlanInfoFoward(int fromIndex,int toIndex,int quantity) throws Exception {
		WorkingRIDdtoMapper.setPickPlanInfoFoward(fromIndex, toIndex, quantity);
	}

	public void freshReturnMaterials() throws Exception {
		WorkingRIDdtoMapper.freshReturnMaterials();
	}

	public String getFIFOlocations(String partNumber) throws Exception {
		return WorkingRIDdtoMapper.getFIFOlocations(partNumber);
	}

	public void freshRIDlocations(String partNumber) throws Exception {
		WorkingRIDdtoMapper.freshRIDlocations(partNumber);
	}

	public void freshRIDlocations4PPO(String PPO) throws Exception {
		WorkingRIDdtoMapper.freshRIDlocations4PPO(PPO);
	}
}
